To concatenate 3 fields on the results of a saved search, do the following: Create a saved search, List > Search > Saved Searches > New. You may select any search type, for this example select Customer. Navigate to the Results tab and add the field “Formula (Text)” and enter the following as the value of the Formula: Concat({firstname},… Continue reading Concatenate 3 fields on the results of a Saved Search
Tag: concatenate
How can we append the line number with the invoice number using a saved search?
Requirement: In the case of any comparison purpose in the script, how can we differentiate each line when there are multiple item lines with the same item? For that, we can create a saved search and include a Formula text column in the results using the expression {number}||’_’||{line}. Here, the {number} represents the document number… Continue reading How can we append the line number with the invoice number using a saved search?
Concatenate the Date field in Excel
When the date field is concatenated with any text field in excel, in the result field the date formate may change. The date value may also be converted to some other format. To avoid this convert the date field to the text field while concatenating. Ex: COCATENATE(TEXT(C2,”dd/mm/yyyy”),E2) In this formula, the date value in C2… Continue reading Concatenate the Date field in Excel