topic Re: Multiple separators in a file... in Application Development and Automation Discussions

Multiple separators in a file...

aris_hidalgo — Wed, 19 Aug 2009 02:45:23 GMT

Hello Experts,

I have a file which has mutiple kinds of separator like '|', tab, etc. So,

how do I split my string table since I do not the kind of separator the file is using during

runtime.

Thank you guys and take care!

Re: Multiple separators in a file...

Former Member — Wed, 19 Aug 2009 04:29:43 GMT

Hi viraylab,

Can you explain the problem in-extenso?

Regards,

Nidhi Kothiyal

Re: Multiple separators in a file...

Former Member — Wed, 19 Aug 2009 04:31:25 GMT

search and replace all separators by a single separator.

then use this separator for all files.

Re: Multiple separators in a file...

former_member188827 — Wed, 19 Aug 2009 04:39:57 GMT

is the file getting generated automatically?is your program running in background?if no provide a separator field on selection screen so that user can enter separator on screen and you can split your text accordingly.

Re: Multiple separators in a file...

Former Member — Wed, 19 Aug 2009 04:41:31 GMT

Firstly,

i think you should you command FIND to find for each separator, then replace each ones by other same separator (for instance replace all |, tab by '#').

Secondly,

split your string to table.

Hope this help

Re: Multiple separators in a file...

Former Member — Wed, 19 Aug 2009 04:44:20 GMT

Hi,

Add, remove all occurences ....

Thanks,

Krishna.

Re: Multiple separators in a file...

aris_hidalgo — Wed, 19 Aug 2009 05:59:02 GMT

The file is generated by a legacy system and I need to uplaod it. The problem is that for some files, they have 2 or more kinds of delimiters like '|' and ','. So I need to do a dynamic checking of delimiter so I can split it correctly.

Re: Multiple separators in a file...

Former Member — Wed, 19 Aug 2009 06:04:56 GMT

are you using LSMW?

if yes then there you can write your code to convert all separators to one particular type.

if not,

then just after gui_upload you can put your code to replace all type of delimiter by a single type.