How to get data between ;'s

[Cherukuri]

Hi,

I have a input source like :

Field1
-------
02102;9;988
4;8;8942333
09323;2;6700
874;34;2323

How can I get the data between ;'s the output file should be like:

Field1
--------
9
8
2
34

so the output file should contain the data between the ;'s of the input file.


Please tell me how to do this.


Thanks in Advance.
Cherukuri

[chulett]

Read the documentation for the Field() function, you can use it to get the 2nd field from your semi-colon delimited string.

[nani0907]

Hi,

Use the feild function and take the postion of the field function to get the data.

Please let me know how it works.

Thanks
Sana.

[Ramya_S]

Hi,

By using Field function--use derivation as specifed here "Field("Input column",";",2)"

Thanks,
Ramya

[priyadarshikunal]

Hi,

Use the feild function and take the postion of the field function to get the data.

Please let me know how it works.

Thanks
Sana.

Why don't you just read the manuals, the syntax of field function is
FIELD (string, delimiter, occurrence [ ,num.substr] )

[dr.murthy]

Hi,

just try with this Field(inputcolumn, ',' ,2).it works fine.

[ray.wurlod]

Hi,

just try with this Field(inputcolumn, ',' ,2).it works fine.

Not if the delimiter is ";".

Attention to detail is SO important in this kind of work.

[Kryt0n]

Hi,

just try with this Field(inputcolumn, ',' ,2).it works fine.

Or alternatively just make the input field delimiter a ';' and then keep column 2...

(of course assuming there isn't further information delimited by something other than a ';')