Highlighted
Contributor

Data format change from List to Text

Hi 

We have two columns in a General list ,i.e SKU Config Group and Config Group. 

The SKU Config Group is having format type of  List  and the Config Group is in text format. Our requirment is to copy the value from SKU Config Group column into Config Group. The reason being there are formulas already buit in the modules based on the text format of the Config Group column and we do not want to change that.

Any pointers on how to convert the List format value from one column into another which is having text format?

 

Thanks 

Regards

Prabakaran

5 REPLIES 5
Community Boss

Re: Data format change from List to Text

@pnataraj ,

 

You can use the NAME() which turns the list formatted line item to a text.

 

Hope this helps,

 

Rob

Contributor

Re: Data format change from List to Text

Community Boss

Re: Data format change from List to Text

HI Prabakaran,

 

Just need a clarification on the list SKU Config Group. If it is a numbered list then use Code() else Name().

Wondering what is the unique identifier for that list and if that matches with Text formatted Property (Either code or Name) then use one of the above.

 

Thanks,

Kavin.

Occasional Contributor

Re: Data format change from List to Text

Hi Prabakaran

You may use the ITEM() function to firstly extract the member of the list and then subsequently use NAME() to get the text value.

Thanks
Yash
Contributor

Re: Data format change from List to Text

First use item() function to extact the list item and then use name() to convert it into text