| View previous topic :: View next topic |
| Author |
Message |
biotech
Joined: 24 Feb 2006
Posts: 145
|
 Posted: Sun Jul 22, 2007 8:03 pm Post subject: unidentified char-help needed for removal |
 |
|
here is the screenshot of the text file that i am generating...one wierd char is appearing and it is messing up the import in excel as CSV file
i need help for removal...(i tried something like this variable=%variable%, but it doesnt work)
 |
|
| Back to top |
|
 |
ManaUser
Joined: 24 May 2007
Posts: 901
|
| Posted: Sun Jul 22, 2007 9:18 pm Post subject: |
|
|
Make a script contianing this:
But copy and paste the mystery character instead of the x. Run it and it will tell you what charcter it is (as a number). Once you know that it will be easier to get rid of. |
|
| Back to top |
|
|
biotech
Joined: 24 Feb 2006
Posts: 145
|
| Posted: Sun Jul 22, 2007 10:32 pm Post subject: |
|
|
thanks for your help but when i paste the character into the script i get a like i pressed return...it only appears in notepad. pspad doesnt
did anyone had similiar problem?? |
|
| Back to top |
|
|
SKAN
Joined: 26 Dec 2005
Posts: 5880
|
| Posted: Sun Jul 22, 2007 10:52 pm Post subject: |
|
|
| biotech wrote: | | when i paste the character into the script i get a like i pressed return... |
Then it should be a solitary carriage-return, a Chr(13) or `r
When creating the CSV make sure you are not using `r and use only `n
 |
|
| Back to top |
|
|
ManaUser
Joined: 24 May 2007
Posts: 901
|
| Posted: Mon Jul 23, 2007 1:31 am Post subject: |
|
|
Or if already have it like that from some other source, you could probably get rid of it like this:
StringReplace Variable, Variable, `r , , All |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
