My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Extracting custom fields|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Extracting custom fields|Power Query|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Extracting custom fields
Avatar
Casey Early
Member
Members
Level 0
Forum Posts: 9
Member Since:
August 20, 2020
sp_UserOfflineSmall Offline
1
January 8, 2022 - 12:37 am
sp_Permalink sp_Print

Hi - we are trying to up a report from our contracts system.

It generates a Custom Fields column which contains all custom fields used in following text string:

Custom field header 1=Custom field text string; Custom field header 2=Custom field text string 2;

We would like to split all the unique fields out into separate columns and then populate or 'null'.

Great resource - hope you can help!

Casey

Screenshot-2022-01-07-143004.pngImage Enlarger

sp_PlupAttachments Attachments
Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
January 9, 2022 - 10:15 am
sp_Permalink sp_Print

Hi Casey,

I'm guessing you can use Split by Delimiter once into columns for the separate columns and then into rows for the data. Then you can remove the duplicate headers? Hard to say without a sample file showing your data before and after so we know exactly what you want.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Geoff McClure, Tom VAN LOO, Misael Gutierrez Sr.
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
David du Toit
Forum Stats:
Groups: 3
Forums: 24
Topics: 6358
Posts: 27805

 

Member Stats:
Guest Posters: 49
Members: 32335
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen