String insert

[#1]

Hi,

   a)  I want to sufix  '_c'  to a field:

      1)  script side

       2)  Expression

  b)  I want to reomve the sufix '_c' to a filed

  1)script

  2) expression

ex:

Filed:   ID

          68

898

566

99

21

100000

987776

Thanks

[petter]

Simply:

RENAME FIELD ID TO ID_c_;

RENAME FIELD ID_c TO ID;

RENAME FIELD ID_c_ TO ID_c;

[#3]

i want the output to be

68_c

98776_c

not 'name field_c'

[sunny_talwar]

Then try this:

LOAD

ID & '_c' as ID

[Qrishna]

Suffix '_c' to a field name:  possible only in script

As petter mentioned:

RENAME FIELD ID TO ID_c_;

RENAME FIELD ID_c TO ID;

RENAME FIELD ID_c_ TO ID_c;

or simply use 'AS' key word eg    ID as ID_c_ :

if you want to suffix '_c' to the data of the field ID:

ID & '_c'  AS ID_new.

To remove:

PurgeChar (ID_new, '_c') AS ID_purged

[#6]

not working ...

I guess

integer  to string..  issue

[MarcoWedel]

to purge the trailing _c you could use:

If(ID like '*_c',Left(ID,Len(ID)-2),ID)

hope this helps

regards

Marco