vshivanna Super Contributor.
Super Contributor.
434 views

Get the cells from Excel and add first name, middle name and last name.

Jump to solution

Hi,

 

I have an excel sheet which have first name, middle name and last name of the new employees. I need to get the full name(first name + middle name + last name) of the new employees. I have used get cell operation in the flow, but comma(,) is the default column delimiter. So, I am getting a result like this: Rahul, Deb, Choudri. But I need like: Rahul Deb Choudri.

 

 

How to solve this...?

 

Regards,

Soundarajan.

 

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.. Steve_Drummond Absent Member..
Absent Member..

Re: Get the cells from Excel and add first name, middle name and last name.

Jump to solution

Add a filter onto your result and use "Replace"; replace All comma (,) with space ( )

0 Likes
1 Reply
Absent Member.. Steve_Drummond Absent Member..
Absent Member..

Re: Get the cells from Excel and add first name, middle name and last name.

Jump to solution

Add a filter onto your result and use "Replace"; replace All comma (,) with space ( )

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.