By dalearyous on

my hypothetical CSV file:
headers: name, age
data: bob;smith, 31

my issue:
when the data is imported (or after, doesn't matter) i would like bob to go to field first name and smith go to field last name. i messed around with feeds tamper explode but i don't think it has the ability to assign items to different fields.

thoughts and/or suggestions?

⋅ Categories: Drupal 7.x

Comments

alibama’s picture

alibama commented

feeds tamper?

dalearyous’s picture

dalearyous commented

feeds tamper doesn't allow me to grab the values and pipe them into separate fields.

styrbaek’s picture

styrbaek
Primary language Danish
commented

Did you find af solution for this?
I'm having the same problem.

donbon’s picture

donbon commented

Possible Solution, which requires Feeds Tamper, as someone above mentioned:
For a "firstname lastname" scenario: e.g. "Fred Durst" to put the First name in one field, Last name in another:

Mapping: Map the CSV column containing the full name to both the first name field as well as the last name field.
Mapping Should look like:
(SOURCE) > (TARGET)
fullname > first name field
fullname > last name field

Use Feeds Tamper to remove the last name from the first name field, and vice versa.
For the First Name Field-

Use Feeds Tamper : Find and Replace

Find:
" *"
Replace
""

(What this does: remove everything after the space in the name)

For the Last Name Field-

Again, Use Feeds Tamper : Find and Replace

Find:
"* "
Replace
""

(What this does: remove every character before the space between the "firstname lastname")

I haven't tested this out and I might have the f & r switched around but the solution is in the find/replace scheme and mapping the column to two seperate fields, "first name" and "last name".