code

[denis115]

Explain me please this part of code :

LOAD F1 as REGION,Upper(trim(PurgeChar(F1,0123456789.))) as REGION1;

[Anil_Babu_Samineni]

Self Explanation is very thought to learn more information rather single line.

But, Here condition works as don't consider as 0123456789. from F1 field and which need to trim and then remaining strings need to be UPPER cases.

Condition should be this

Upper(trim(PurgeChar(F1,'0123456789.'))) as REGION1

[its_anandrjs · Accepted solution]

In the given load script part by explaining for you

1.LOAD  This is load statement start part with LOAD key word.

2. F1 as REGION,  THis is the field aliasing actual field name is F1 but it is renamed or Alias as REGION

3. Upper(   UPPER function make Upper case to the field items

        trim(   TRIM function removes any spaces and trims it from all side Right and Left

         PurgeChar(F1,0123456789.)  PURGECHAR function not accept the numbers 0123456789 on the field and removes all this from field

              )

              ) as REGION1;  This is again renaming of the field F1.

[denis115]

thank you!

[denis115]

thank you!

[Anil_Babu_Samineni]

Please flag this answer and you done assumed answer. I would ask you to goop back and flag correct answer any one of the answer so then next helpers May understood..

If you are not found, let it be..