General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>Hi Doris. Thanks for your reply
>
>When I do :
>copy to MyText delimited with character '|' ........ I get each fields separated by | and DoubleQuote as in "JoeBloggs"|"Boston"|"USA"|
>
>copy to MyText delimitied with '|' ... I get each field enclosed in | | and separated by a comma as in |Joe Bloggs|,|Boston|,|USA|
>
>Still cannot get anything t produce ----> Joe Bloggs|Boston|USA| i.e. Each field separated by --> |
If you're willing to make it a two step process, use DELIMITED WITH (some character you KNOW isn't in the data) and then use STRTOFILE(STRTRAN(FILETOSTR(filename), (that character) ,'|'), filename). (Hope I got that right...)
Chris.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only