add a prefix to data when loading from excel

[avishaiz]

i have data loaded from excel

the data is a number but want to add the prefix "PRD000" to the field

how do i do that?

[oknotsen · Accepted solution]

Edit your load script and add it.

Current line of code:

someFieldName,

Change it to

'PRD000' & someFieldName as someFieldName,

[arulsettu]

load

'PRD000'&filedname as field

[avishaiz]

thank you for the help

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

[avishaiz]

sorry for the late response, i was out of the office

is this option disabled?

i can find it...

[oknotsen]

You don't see a big green start with the text "Correct Answer" at the end of each post?

This image:

[avishaiz]

No all i have in actions is mark as helpful