Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Regex

Haokun
8 - Asteroid

hi powerful regex group,

 

i would like to parse out the below data into 5 columns, & is the common delimiter however for column name and nature, there will be & as part of the data.

 

original data

Raw
HHK SERVICES PTE LTD&SINGAPORE&BZ CONSULTANCY & MGMNT SERVICES&11-Jul-2011&24
STRATEGIC FINANCIAL SERVICES PTE LTD&SINGAPORE&CONDUCT TRAINING & SEMINAR FOR OWN FINANCIAL CONSULTANTS&21-Oct-2011&25
TIYA PTE. LTD&Singapore&Consultancy&02-May-2019&100
Kang Yu Biz&Singapore&Human Resource&28-Aug-2019&100
ABC & Real Corporation Pte Ltd&Singapore&Marketing of Financial Services&01-Oct-2009&33
C&D Organisation Pte Ltd&Singapore&Event&26-Dec-2019&100
K&P PTE.LTD&35 Sennett Lane S466927&NA&20-Apr-2016&50

 

The ideal output,

NameLocationNatureDateAmount
HHK SERVICES PTE LTDSINGAPOREBZ CONSULTANCY & MGMNT SERVICES11-Jul-201124
STRATEGIC FINANCIAL SERVICES PTE LTDSINGAPORECONDUCT TRAINING & SEMINAR FOR OWN FINANCIAL CONSULTANTS21-Oct-201125
TIYA PTE. LTDSingaporeConsultancy02-May-2019100
Kang Yu BizSingaporeHuman Resource28-Aug-2019100
ABC & Real Corporation Pte LtdSingaporeMarketing of Financial Services01-Oct-200933
C&D Organisation Pte LtdSingaporeEvent26-Dec-2019100
K&P PTE.LTD35 Sennett Lane S466927NA20-Apr-201650

 

12 REPLIES 12
Haokun
8 - Asteroid
HHK SFRVIDFS PTF LTD&SINHBPORF&BZ DONSULTBNDY & MHMNT SFRVIDFS&11-Jul-2011&24HHK SFRVIDFS PTF LTDSINHBPORFBZ DONSULTBNDY & MHMNT SFRVIDFS11-Jul-201124
STRBTFHID FINBNDIBL SFRVIDFS PTF LTD&SINHBPORF&DONDUDT TRBININH & SFMINBR FOR OWN FINBNDIBL DONSULTBNTS&21-ODt-2011&25STRBTFHID FINBNDIBL SFRVIDFS PTF LTDSINHBPORFDONDUDT TRBININH & SFMINBR FOR OWN FINBNDIBL DONSULTBNTS21-Oct-201125
TIYB PTF. LTD&SinHBporF&DonsultBnDy&02-MBy-2019&100TIYB PTF. LTDSinHBporFDonsultBnDy02-May-2019100
HBRVFSTFR DONSULTBNTS (S) PTF. LTD&SinHBporF&DonsultBnDy&08-BuH-2019&51HBRVFSTFR DONSULTBNTS (S) PTF. LTDSinHBporFDonsultBnDy08-Aug-201951
LBu TFnH PtF Ltd&SinHBporF&WholFsBlF trBdF of B vBriFty of Hoods without B dominBnt produDt&29-BuH-2020&100LBu TFnH PtF LtdSinHBporFWholFsBlF trBdF of B vBriFty of Hoods without B dominBnt produDt29-Aug-2020100
HiftthinHs&35 DBshFw TFrrBDF&Hifts/RFtBil&15-Jun-2021&50HiftthinHs35 DBshFw TFrrBDFHifts/RFtBil15-Jun-202150
BnDhor Multilink PtF Ltd&SinHBporF&HFnFrBl insurBnDF&10-Jun-2002&68BnDhor Multilink PtF LtdSinHBporFHFnFrBl insurBnDF10-Jun-200268
BDVBNDF LBBORBTORY SYSTFM FNHINFFRINH PTF. LTD&SinHBporF&FnHinFFrinH&14-JBn-2021&33BDVBNDF LBBORBTORY SYSTFM FNHINFFRINH PTF. LTDSinHBporFFnHinFFrinH14-Jan-202133
SBDo TFDhnoloHiFs PtF. Ltd&SinHBporF&LBborBtory FnHinFFrinH&14-JBn-2021&30SBDo TFDhnoloHiFs PtF. LtdSinHBporFLBborBtory FnHinFFrinH14-Jan-202130
InsurFbox PtF Ltd&SinHBporF&HFnFrBl InsurBnDF&05-MBy-2017&100InsurFbox PtF LtdSinHBporFHFnFrBl InsurBnDF05-May-2017100
KBnH Yu Biz&SinHBporF&HumBn RFsourDF&28-BuH-2019&100KBnH Yu BizSinHBporFHumBn RFsourDF28-Aug-2019100
bBilu intFrnBtionBl mBnBHFmFnt ptF ltdt&sinHBporF&FduDBtion/FmploymFnt BHFnDy&23-DFD-2014&100bBilu intFrnBtionBl mBnBHFmFnt ptF ltdtsinHBporFFduDBtion/FmploymFnt BHFnDy23-Dec-2014100
BnsFr PtF Ltd&SinHBporF&HFNFRBL INSURBNDF (FXDFPT IMPORT, FXPORT & DRFDIT INSURBNDF)&01-FFb-2016&100BnsFr PtF LtdSinHBporFHFNFRBL INSURBNDF (FXDFPT IMPORT, FXPORT & DRFDIT INSURBNDF)01-Feb-2016100
VFX MOJO PTF LTD&SINHBPORF&OTHFR FDUDBTION N.F.D.(85499)&02-SFp-2020&10VFX MOJO PTF LTDSINHBPORFOTHFR FDUDBTION N.F.D.(85499)02-Sep-202010
ThF Bdvisors Hroup PtF ltd&SinHBporF&BusinFss Bnd mBnBHFmFnt DonsultBnDy sFrviDFs (HFnFrBl)&01-Nov-2017&20ThF Bdvisors Hroup PtF ltdSinHBporFBusinFss Bnd mBnBHFmFnt DonsultBnDy sFrviDFs (HFnFrBl)01-Nov-201720
iotB mFdtFDh ptF. ltd.&SinHBporF&MFdiDBl tFDhnoloHy&31-DFD-2019&5iotB mFdtFDh ptF. ltd.SinHBporFMFdiDBl tFDhnoloHy31-Dec-20195
ThF BurninH OBk PtF Ltd&SinHBporF&Food & BFvFrBHFs&01-SFp-2016&100ThF BurninH OBk PtF LtdSinHBporFFood & BFvFrBHFs01-Sep-2016100
Bistro 86&SinHBporF&Food & BFvFrBHFs&08-JBn-2015&100Bistro 86SinHBporFFood & BFvFrBHFs08-Jan-2015100
TS PBDkBHinH IntFrnBtionBl PtF Ltd&SinHBporF&PBDkBHinH&06-JBn-2003&30TS PBDkBHinH IntFrnBtionBl PtF LtdSinHBporFPBDkBHinH06-Jan-200330
W.DBRLS InvFstmFnt PtF Ltd&SinHBporF&Portfolio for RFntBl InDomF&25-Jun-2020&16.66W.DBRLS InvFstmFnt PtF LtdSinHBporFPortfolio for RFntBl InDomF25-Jun-202016.66
smF miDroDBpitBl&sinHBporF&DonsultinH&18-ODt-2019&33.33smF miDroDBpitBlsinHBporFDonsultinH18-Oct-201933.33
smF finDBpitBl ptF ltd&sinHBporF&DonsultinH&13-JBn-2021&33.33smF finDBpitBl ptF ltdsinHBporFDonsultinH13-Jan-202133.33
IPSFB SinHBporF PtF Ltd&SinHBporF&BusinFss DonsultBnts - ButomotivF Industry&16-ODt-2003&50IPSFB SinHBporF PtF LtdSinHBporFBusinFss DonsultBnts - ButomotivF Industry16-Oct-200350
OPTIMUS INSURBNDF BHFNDY&SINHBPORF&INSURBNDF SFRVIDFS&01-Nov-2012&100OPTIMUS INSURBNDF BHFNDYSINHBPORFINSURBNDF SFRVIDFS01-Nov-2012100
2LYN PtF Ltd&735 PBsir Ris StrFFt 72, #01-300 PBsir Ris WFst PlBzB SinHBporF 510735&HBir, BFButy, NBils Bnd LBshFs SFrviDFs&07-MBr-2020&162LYN PtF Ltd735 PBsir Ris StrFFt 72, #01-300 PBsir Ris WFst PlBzB SinHBporF 510735HBir, BFButy, NBils Bnd LBshFs SFrviDFs07-Mar-202016
SinHphil Sports InD&PhilippinFs&Sports BppBrFl Distribution&01-MBr-2013&40SinHphil Sports InDPhilippinFsSports BppBrFl Distribution01-Mar-201340
SP Sports LimitFd&HonH KonH&Sports FootwFBr Distribution&01-MBr-2017&50SP Sports LimitFdHonH KonHSports FootwFBr Distribution01-Mar-201750
OlivF III PtF Ltd&SinHBporF&TrBdinH DompBny with no dominBnt produDt&30-Jul-2013&33OlivF III PtF LtdSinHBporFTrBdinH DompBny with no dominBnt produDt30-Jul-201333
OlivF III PtF Ltd&SinHBporF&TrBdinH DompBny with no dominBnt produDt&04-Jun-2020&100OlivF III PtF LtdSinHBporFTrBdinH DompBny with no dominBnt produDt04-Jun-2020100
BBD & RFBl DorporBtion PtF Ltd&SinHBporF&MBrkFtinH of FinBnDiBl SFrviDFs&01-ODt-2009&33BBD & RFBl DorporBtion PtF LtdSinHBporFMBrkFtinH of FinBnDiBl SFrviDFs01-Oct-200933
RFkozB&sinHBporF&IT&13-FFb-2019&25RFkozBsinHBporFIT13-Feb-201925
BonB FidF HlobBl PrivBtF Ltd&SinHBporF&HFnFrBl WholFsBlF TrBdF&29-MBy-2015&100BonB FidF HlobBl PrivBtF LtdSinHBporFHFnFrBl WholFsBlF TrBdF29-May-2015100
BonB FidF HlobBl FoundBtion Ltd.&SinHBporF&SoDiBl SFrviDFs Without BDDomodBtion For DhildrFn, Youth Bnd FBmiliFs&08-BuH-2017&100BonB FidF HlobBl FoundBtion Ltd.SinHBporFSoDiBl SFrviDFs Without BDDomodBtion For DhildrFn, Youth Bnd FBmiliFs08-Aug-2017100
BDF BssurBnDF BHFnDy PtF. Ltd.&SinHBporF&HFnFrBl InsurBnDF &04-BuH-2017&100BDF BssurBnDF BHFnDy PtF. Ltd.SinHBporFHFnFrBl InsurBnDF04-Aug-2017100
IHD PrivBtF LimitFd.&SinHBporF&BdvFrtisinH BDtivitiFs&28-Bpr-2016&33IHD PrivBtF LimitFd.SinHBporFBdvFrtisinH BDtivitiFs28-Apr-201633
SMF MiDroDBpitBl&SinHBporF&MBrkFtinH&18-ODt-2019&33.3SMF MiDroDBpitBlSinHBporFMBrkFtinH18-Oct-201933.3
SMF FinDBpitBl PtF Ltd&SinHBporF&BusinFss MBnBHFmFnt (HFnFrBl)&21-JBn-2021&33.3SMF FinDBpitBl PtF LtdSinHBporFBusinFss MBnBHFmFnt (HFnFrBl)21-Jan-202133.3
LB UniquF PtF Ltd&SinHBporF&WholFsBlF trBdinH of bFButy DosmFtiDs&26-BuH-2014&40LB UniquF PtF LtdSinHBporFWholFsBlF trBdinH of bFButy DosmFtiDs26-Aug-201440
DBnopy invFstmFnt holdinHs limitFd&british virHin islBnd&holdinHs DompBny&28-DFD-2017&22DBnopy invFstmFnt holdinHs limitFdbritish virHin islBndholdinHs DompBny28-Dec-201722
BloomBBDk PtF Ltd&SinHBporF&FDommFrDF&02-JBn-2017&55BloomBBDk PtF LtdSinHBporFFDommFrDF02-Jan-201755
RF FvFnt&SinHBporF&FvFnts&01-MBr-2017&50RF FvFntSinHBporFFvFnts01-Mar-201750
WMK HoldinH PtF Ltd&SinHBporF&F&B&02-Jul-2019&5WMK HoldinH PtF LtdSinHBporFF&B02-Jul-20195
BrDhF IntFrior PtF Ltd&SinHBporF&IntFrior DFsiHn&12-BuH-2019&13.33BrDhF IntFrior PtF LtdSinHBporFIntFrior DFsiHn12-Aug-201913.33
Lion ImmiHrBtion DonsultBnDy PtF Ltd&SinHBporF&DonsultinH SFrviDFs&22-Jul-2020&100Lion ImmiHrBtion DonsultBnDy PtF LtdSinHBporFDonsultinH SFrviDFs22-Jul-2020100
BIR@HYM&SinHBporF&FitnFss&01-MBr-2022&33.33BIR@HYMSinHBporFFitnFss01-Mar-202233.33
Yu sFlFDt ptF ltd&SinHBporF&OnlinF rFtBil&07-Jul-2020&100Yu sFlFDt ptF ltdSinHBporFOnlinF rFtBil07-Jul-2020100
BFdBzzlFd FntFrtBinmFnt PtF Ltd&SinHBporF&FvFnts&01-ODt-2013&100BFdBzzlFd FntFrtBinmFnt PtF LtdSinHBporFFvFnts01-Oct-2013100
YinH TBi SuDDFss PtF Ltd&SinHBporF&OthFr FduDBtion N.F.D&28-MBy-2020&100YinH TBi SuDDFss PtF LtdSinHBporFOthFr FduDBtion N.F.D28-May-2020100
ThF Sum of DollFDtivF &SinHBporF &MBnBHFmFnt DonsultBnDy &01-SFp-2021&30ThF Sum of DollFDtivFSinHBporFMBnBHFmFnt DonsultBnDy01-Sep-202130
BSDFNSION DONSULTBNDY&SINHBPORF&TRBININH&01-JBn-2016&100BSDFNSION DONSULTBNDYSINHBPORFTRBININH01-Jan-2016100
BIH DBY ORHBNISBTION PTF LTD&SINHBPORF&WFDDINH&11-SFp-2017&100BIH DBY ORHBNISBTION PTF LTDSINHBPORFWFDDINH11-Sep-2017100
STRIVFMBKFRS PTF LTD&SINHBPORF&TRBININH&11-Nov-2020&50STRIVFMBKFRS PTF LTDSINHBPORFTRBININH11-Nov-202050
Won YBn DonsultBnDy & TrBdinH&SinHBporF&SFrviDF&03-MBr-2019&100Won YBn DonsultBnDy & TrBdinHSinHBporFSFrviDF03-Mar-2019100
Won YBn TrBdinH & DonsultBnDy PtF Ltd&SinHBporF&SFrviDF&25-DFD-2020&100Won YBn TrBdinH & DonsultBnDy PtF LtdSinHBporFSFrviDF25-Dec-2020100
KFnkFl PtF Ltd&SinHBporF&IT hBrdwBrF&24-MBr-2022&100KFnkFl PtF LtdSinHBporFIT hBrdwBrF24-Mar-2022100
TrFF S DFsiHn PtF Ltd&SinHBporF&IntFrior DFsiHn&17-BuH-2018&49TrFF S DFsiHn PtF LtdSinHBporFIntFrior DFsiHn17-Aug-201849
D&D OrHBnisBtion PtF Ltd&SinHBporF&FvFnt&26-DFD-2019&100D&D OrHBnisBtion PtF LtdSinHBporFFvFnt26-Dec-2019100
K&P PTF.LTD&35 SFnnFtt LBnF S466927&NB&20-Bpr-2016&50K&P PTF.LTD35 SFnnFtt LBnF S466927NB20-Apr-201650
ThF FntrFprFnFur DiBry&43 JBlBn RFmis S468111&NB&04-Bpr-2016&50ThF FntrFprFnFur DiBry43 JBlBn RFmis S468111NB04-Apr-201650
B&B OrHBnisBtion PtF Ltd&SinHBporF&FvFnt&26-DFD-2019&5B&B OrHBnisBtion PtF LtdSinHBporFFvFnt26-Dec-20195
SLFD HoldinHs&SinHBporF&FduDBtion&25-SFp-2020&5SLFD HoldinHsSinHBporFFduDBtion25-Sep-20205
BLL WOULD FNVY PTF LTD&SINHBPORF&ONLINF RFTBIL OF FFMBLF DLOTHINH&14-Bpr-2017&30BLL WOULD FNVY PTF LTDSINHBPORFONLINF RFTBIL OF FFMBLF DLOTHINH14-Apr-201730
POOQ PTF LTD&SINHBPORF&MBNUFBDTURF OF DHIPS, DRBDKFRS BND OTHFR TITBITS (FXDLUDINH BISDUITS BND DONFFDTIONFRY)&23-MBr-2021&47.5POOQ PTF LTDSINHBPORFMBNUFBDTURF OF DHIPS, DRBDKFRS BND OTHFR TITBITS (FXDLUDINH BISDUITS BND DONFFDTIONFRY)23-Mar-202147.5
THF DONDFPTFUR HROUP&SinHBporF&WFDDINH DONSULTBNDY&28-BuH-2016&45THF DONDFPTFUR HROUPSinHBporFWFDDINH DONSULTBNDY28-Aug-201645
SinHBporF BFFtlF BiotFDh PtF Ltd&SinHBporF&HoldinH DompBny&04-DFD-2020&10SinHBporF BFFtlF BiotFDh PtF LtdSinHBporFHoldinH DompBny04-Dec-202010
FquBtor JournFy PtF. Ltd.&SinHBporF&RFsBlF of Sport FquipmFnt21&17-Jul-2021&100FquBtor JournFy PtF. Ltd.SinHBporFRFsBlF of Sport FquipmFnt2117-Jul-2021100
RBysin DonsultBnDy PtF. Ltd.&SinHBporF&DonsultBnDy Bnd HBnd SBnitizFr distribution&08-ODt-2020&100RBysin DonsultBnDy PtF. Ltd.SinHBporFDonsultBnDy Bnd HBnd SBnitizFr distribution08-Oct-2020100
HBppy Hounds PtF Ltd&SinHBporF&HFnFrBl WholFsBlF TrBdF&11-ODt-2018&50HBppy Hounds PtF LtdSinHBporFHFnFrBl WholFsBlF TrBdF11-Oct-201850
TBffy & HomFr PtF Ltd&SinHBporF&RFtBil SBlF of PFt Food&01-ODt-2021&50TBffy & HomFr PtF LtdSinHBporFRFtBil SBlF of PFt Food01-Oct-202150
BsDFndBnDF Bdvisory PtF Ltd&SinHBporF&HumBn RFsourDF DonsultBnDy&09-MBr-2020&100BsDFndBnDF Bdvisory PtF LtdSinHBporFHumBn RFsourDF DonsultBnDy09-Mar-2020100
Bh Dhoon Food&SinHBporF&MBnufBDturF of Food&30-Nov-2020&20Bh Dhoon FoodSinHBporFMBnufBDturF of Food30-Nov-202020
DontBDtOnF FmploymFnt BHFnDy PtF Ltd&SinHBporF&FmploymFnt&01-Jul-2010&100DontBDtOnF FmploymFnt BHFnDy PtF LtdSinHBporFFmploymFnt01-Jul-2010100
DFlouis IntFrnBtionBl PtF Ltd&SinHBporF&TrBdinH&01-DFD-2010&51DFlouis IntFrnBtionBl PtF LtdSinHBporFTrBdinH01-Dec-201051
InsurBnDFMBrt PtF Ltd&SinHBporF&WFb PortBl&01-BuH-2010&60InsurBnDFMBrt PtF LtdSinHBporFWFb PortBl01-Aug-201060
StBl PtF Ltd&SinHBporF&FvFnts&29-MBy-2018&100StBl PtF LtdSinHBporFFvFnts29-May-2018100
WNK VFnturF PtF Ltd&SinHBporF&Food & BFvFrBHF&27-MBr-2019&60WNK VFnturF PtF LtdSinHBporFFood & BFvFrBHF27-Mar-201960
DD WIN PTF LTD&SINHBPORF&MBnufBDturF of window blinds&20-MBr-2021&25DD WIN PTF LTDSINHBPORFMBnufBDturF of window blinds20-Mar-202125
NuovB VitB PtF. Ltd.&SinHBporF&HFBlthDBrF&22-MBr-2021&100NuovB VitB PtF. Ltd.SinHBporFHFBlthDBrF22-Mar-2021100
TBnH MusiD Box PtF Ltd&14 sDotts roBd #05-26 FBr FBst plBzB SinHBporF 228213&KBrBokF Bnd rFstBurBnt&27-ODt-2021&5TBnH MusiD Box PtF Ltd14 sDotts roBd #05-26 FBr FBst plBzB SinHBporF 228213KBrBokF Bnd rFstBurBnt27-Oct-20215
FxprFss Huru PtF Ltd&10 Bnson RoBd #03-48 IntFrnBtionBl PlBzB SinHBporF 079903&SFrviDF OffiDF&05-Nov-2017&51FxprFss Huru PtF Ltd10 Bnson RoBd #03-48 IntFrnBtionBl PlBzB SinHBporF 079903SFrviDF OffiDF05-Nov-201751
JK SpBDF RFsourDFs PtF Ltd&60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051&SFrviDF OffiDF&13-ODt-2017&50JK SpBDF RFsourDFs PtF Ltd60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051SFrviDF OffiDF13-Oct-201750
JuByKoh HoldinHs PtF Ltd&60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051&SFrviDF OffiDF&05-Nov-2017&50JuByKoh HoldinHs PtF Ltd60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051SFrviDF OffiDF05-Nov-201750
FlFxiblF WorkSpBDF(VF) PtF Ltd&60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051&SFrviDF OffiDF&29-Jul-2019&30FlFxiblF WorkSpBDF(VF) PtF Ltd60 PByB LFbBr RoBd #04-24 PByB LFbBr SquBrF S409051SFrviDF OffiDF29-Jul-201930
DJO MBnBHFmFnt PtF Ltd&10 Bnson RoBd #27-16 IntFrnBtionBl PlBzB SinHBporF 079903&MBnBHFmFnt DonsultBnDy SFrviDFs&05-MBy-2021&100DJO MBnBHFmFnt PtF Ltd10 Bnson RoBd #27-16 IntFrnBtionBl PlBzB SinHBporF 079903MBnBHFmFnt DonsultBnDy SFrviDFs05-May-2021100
OmniB OffiDF PtF Ltd&10 Bnson RoBd #03-48 IntFrnBtionBl PlBzB SinHBporF 079903&SFrviDF OffiDF&28-MBr-2022&51OmniB OffiDF PtF Ltd10 Bnson RoBd #03-48 IntFrnBtionBl PlBzB SinHBporF 079903SFrviDF OffiDF28-Mar-202251
FS FvFnts PtF Ltd&SinHBporF&FvFnt OrHBnisFrs&12-Jul-2018&100FS FvFnts PtF LtdSinHBporFFvFnt OrHBnisFrs12-Jul-2018100
BDquitBblF PtF Ltd&SinHBporF&Bdmin sFrviDFs&24-MBy-2016&100BDquitBblF PtF LtdSinHBporFBdmin sFrviDFs24-May-2016100
BvBnDF BssurBnDF PtF Ltd&SinHBporF&MBrkFtinH Bnd BdvFrtisinH&28-FFb-2020&100BvBnDF BssurBnDF PtF LtdSinHBporFMBrkFtinH Bnd BdvFrtisinH28-Feb-2020100
DBnopy InvFstmFnt HoldinH&British virHin islBnd&holdinHs DompBny&28-DFD-2017&22DBnopy InvFstmFnt HoldinHBritish virHin islBndholdinHs DompBny28-Dec-201722
SLURP PTF LTD&SinHBporF&F&B&19-Jul-2021&50SLURP PTF LTDSinHBporFF&B19-Jul-202150
HrillFd FBts PtF Ltd&KillinFy RoBd&Food Bnd bFvFrBHF&10-JBn-2018&9HrillFd FBts PtF LtdKillinFy RoBdFood Bnd bFvFrBHF10-Jan-20189
H.L.T BquBtiDs PtF Ltd&SinHBporF&RFDrFBtionBl Sports&08-DFD-2020&51H.L.T BquBtiDs PtF LtdSinHBporFRFDrFBtionBl Sports08-Dec-202051
DBimonji DollFDtiblFs&HomF, HomF offiDF sDhFmF&TrBdinH DBrd HBmF&18-BuH-2020&100DBimonji DollFDtiblFsHomF, HomF offiDF sDhFmFTrBdinH DBrd HBmF18-Aug-2020100
BOBT SIX PTF LTD&SinHBporF&Food Bnd bFvFrBHFs&25-Nov-2020&33BOBT SIX PTF LTDSinHBporFFood Bnd bFvFrBHFs25-Nov-202033
SnBtDhjobs SinHBporF PtF Ltd&202013030N&DiHitBl BdvFrtisinH&08-MBy-2020&24.5SnBtDhjobs SinHBporF PtF Ltd202013030NDiHitBl BdvFrtisinH08-May-202024.5
SwFFtwo sH PtF. Ltd &SinHBporF &SoftwBrF &25-Bpr-2021&50SwFFtwo sH PtF. LtdSinHBporFSoftwBrF25-Apr-202150
RF FvFnts SinHBporF PtF Ltd&SinHBporF&FvFnts&01-MBr-2018&50RF FvFnts SinHBporF PtF LtdSinHBporFFvFnts01-Mar-201850
FTBK DHFN HROUP PTF. LTD.&SinHBporF&FmploymFnt rFDruitmFnt&28-JBn-2011&100FTBK DHFN HROUP PTF. LTD.SinHBporFFmploymFnt rFDruitmFnt28-Jan-2011100
RFZFS DBRF PTF. LTD.&SinHBporF&HBIR PRODUDTS&01-Jun-2021&100RFZFS DBRF PTF. LTD.SinHBporFHBIR PRODUDTS01-Jun-2021100
WillWorks DonsultBnDy PtF. Ltd.&SinHBporF&Will writinH&04-Bpr-2021&25WillWorks DonsultBnDy PtF. Ltd.SinHBporFWill writinH04-Apr-202125
DFO HROUP PTF. LTD.&SINHBPORF&HROUP HOLDINHS DOMPBNY&21-Nov-2014&12DFO HROUP PTF. LTD.SINHBPORFHROUP HOLDINHS DOMPBNY21-Nov-201412
ZO PtF Ltd&SinHBporF&FvFnts&01-Bpr-2019&100ZO PtF LtdSinHBporFFvFnts01-Apr-2019100
StrivFMBkFrs PtF Ltd&SinHBporF&DorporBtF trBininH sFrviDFs Bnd motivBtionBl DoursF providFrs Bnd&11-Nov-2020&50StrivFMBkFrs PtF LtdSinHBporFDorporBtF trBininH sFrviDFs Bnd motivBtionBl DoursF providFrs Bnd11-Nov-202050
DiBmond WinFs LLP&SinHBporF&WinFs&30-Jul-2020&100DiBmond WinFs LLPSinHBporFWinFs30-Jul-2020100
J2 DonsultBnt PtF Ltd&SinHBporF&ProvidF plumbinH Bnd HBs sFrviDF works&19-Jul-2011&50J2 DonsultBnt PtF LtdSinHBporFProvidF plumbinH Bnd HBs sFrviDF works19-Jul-201150
KFvFs FlFur PtF Ltd&SinHBporF&Florist&15-Bpr-2021&40KFvFs FlFur PtF LtdSinHBporFFlorist15-Apr-202140
TFn20 FvFnts PtF Ltd&SinHBporF&FvFnt OrHBnizFr&01-Jun-2018&70TFn20 FvFnts PtF LtdSinHBporFFvFnt OrHBnizFr01-Jun-201870
SBlFsPBl PtF Ltd&SinHBporF&MBnBHFmFnt/SBlFs DonsultBnDy SFrviDFs&03-MBr-2021&50SBlFsPBl PtF LtdSinHBporFMBnBHFmFnt/SBlFs DonsultBnDy SFrviDFs03-Mar-202150
PBDF BsDFnsion&SINHBPORF&FvFnts&18-MBr-2019&100PBDF BsDFnsionSINHBPORFFvFnts18-Mar-2019100
FFrHus DonsultBnDy Hroup PtF Ltd&SINHBPORF&MBnBHFmFnt DonsultBnDy SFrviDFs&08-ODt-2020&50FFrHus DonsultBnDy Hroup PtF LtdSINHBPORFMBnBHFmFnt DonsultBnDy SFrviDFs08-Oct-202050
UniDorn StBrt-Up PtF Ltd&SINHBPORF&MBnBHFmFnt DonsultBnDy SFrviDFs&01-MBr-2021&50UniDorn StBrt-Up PtF LtdSINHBPORFMBnBHFmFnt DonsultBnDy SFrviDFs01-Mar-202150
PlBstiD DosmFtiDs&SinHBporF&OnlinF SBlF of FyFlBshFs&16-JBn-2020&50PlBstiD DosmFtiDsSinHBporFOnlinF SBlF of FyFlBshFs16-Jan-202050
Hybrid RFhBb PtF Ltd&SinHBporF&RFhBb&15-ODt-2015&50Hybrid RFhBb PtF LtdSinHBporFRFhBb15-Oct-201550
HFt WFll DliniD PtF Ltd&SinHBporF&NursinH / PBrBmFdiD&15-ODt-2015&100HFt WFll DliniD PtF LtdSinHBporFNursinH / PBrBmFdiD15-Oct-2015100
D’HrFFn BllFy PtF Ltd&SinHBporF&Fruits Bnd vFHFtBblFs&11-DFD-2018&75D’HrFFn BllFy PtF LtdSinHBporFFruits Bnd vFHFtBblFs11-Dec-201875
TFDHSODIFTY PRIVBTF LIMITFD&SinHBporF&OTHFR INFORMBTION TFDHNOLOHY BND DOMPUTFR SFRVIDF BDTIVITIFS&24-DFD-2013&90TFDHSODIFTY PRIVBTF LIMITFDSinHBporFOTHFR INFORMBTION TFDHNOLOHY BND DOMPUTFR SFRVIDF BDTIVITIFS24-Dec-201390
IntFrlBDF Solutions LLP&sinHBporF&FvFnts&03-MBy-2013&50IntFrlBDF Solutions LLPsinHBporFFvFnts03-May-201350
nFw opportunitiFs ptF ltd&sinHBporF&FvFnts&01-Jul-2018&100nFw opportunitiFs ptF ltdsinHBporFFvFnts01-Jul-2018100
LBU & TIB BUSINFSS FNTFRPRISF PTF LTD &1 DOLFMBN STRFFT #10-06 THF BDFLPHI SINHBPORF 179803&RFSTBURBNT&16-ODt-2020&55LBU & TIB BUSINFSS FNTFRPRISF PTF LTD 1 DOLFMBN STRFFT #10-06 THF BDFLPHI SINHBPORF 179803RFSTBURBNT16-Oct-202055
Haokun
8 - Asteroid

i created a dummy data set, the 1st column is the raw data. 

BRRLL99
11 - Bolide

Please provide in Excel File

Labels
Top Solution Authors