Joined: 21 Mar 2007 Posts: 66 Location: Chennai, Tamilnadu, India
Hi All,
Can we retrieve part of SYMNAME value?
I have an input file like below,
Code:
Ramanan,1234.5678
The SYMNAME dataset has
Name,1,10,CH
Value,3,9,CH
Is there any way to retrieve only first three characters of Name, i.e Ram and 1234.56 (truncate two decimal places) of Value alone to output dataset.
Please don't suggest relative position method, because my input dataset is 700 byte long and there are around 60 fields defined with SYMNAMES. My requirement is to retrieve part of data from certain columns (SYMNAMES).