Ask Your Question

How to remove .0.value from end of all field names?

asked 2017-10-09 13:03:34 -0500

jwhalen gravatar image

Working with XML Data. After using the field flattener to flatten XML structure all may field names end with .0.value. How can I remove these without specifying every field name in the field renamer?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2017-10-09 13:04:04 -0500

jwhalen gravatar image

updated 2017-10-09 14:06:28 -0500

metadaddy gravatar image

Use this expression in field Renamer to remove .0.value from end of all field names:

  • Source Field Expression: /'(.*)\.0\.value'
  • Target Field Expression: /$1
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-09 13:03:34 -0500

Seen: 222 times

Last updated: Oct 09 '17